FaAwardLetterQueue 
Logical Entity Name  FaAwardLetterQueue 
Default Table Name  FaAwardLetterQueue 
Physical Only  NO 
Definition 
 
Note 
 

FaAwardLetterQueue Columns 
ColumnName  Domain  Datatype  NULL  Definition 
FaAwardLetterQueueId(PK)    int  NO 
 
SyStudentID(FK)    int  NO 
 
FaStudentAYId(FK)    int  NO 
 
SyCampusId(FK)    int  NO 
 
Status    char(1)  NO 
 
AwardYear    char(7)  NO 
 
AwardLetter    varchar(200)  NO 
 
FaAdvisorID(FK)    int  YES 
 
UserID(FK)    int  NO 
 
DateAdded    datetime  NO 
 
dateLstMod    datetime  NO 
 
ts    timestamp  NO 
 
Destination    char(1)  NO 
 

FaAwardLetterQueue Primary and Unique Keys 
Key Name  Key Type  Keys 
PK_FaAwardLetterQueue_FaAwardLetterQueueId  PrimaryKey  FaAwardLetterQueueId 

FaAwardLetterQueue Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
SyStaff  Non-Identifying  Zero or One to Zero or More  FK_FaAwardLetterQueue_FaAdvisorID_SyStaff_SyStaffID      FaAdvisorID  NO  YES 
FaStudentAY  Non-Identifying  One To Zero or More  FK_FaAwardLetterQueue_FaStudentAYID_FaStudentAY_FaStudentAYID      FaStudentAYId  NO  YES 
SyCampus  Non-Identifying  One To Zero or More  FK_FaAwardLetterQueue_SyCampusID_SyCampus_SyCampusID      SyCampusId  NO  YES 
syStudent  Non-Identifying  One To Zero or More  FK_FaAwardLetterQueue_SyStudentID_SyStudent_SyStudentID      SyStudentID  NO  YES 
SyStaff  Non-Identifying  One To Zero or More  FK_FaAwardLetterQueue_UserID_SyStaff_SyStaffID      UserID  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 

FaAwardLetterQueue Check Constraints 
Check Constraint Name  CheckConstraint